 CREATE EXTERNAL TABLE jms_ods.yl_cn_mysql_lmdm_sys_tail_dispatch_area_staff(
   `id` int COMMENT '',
   `tail_code` string COMMENT '单元区域编码（关联字段）',
   `tail_id` int COMMENT '单元区域ID（关联字段）',
   `staff_id` int COMMENT '员工ID',
   `staff_code` string COMMENT '员工编码',
   `staff_name` string COMMENT '员工名称')
 COMMENT '单元区域-员工关联表'
 PARTITIONED BY (
   `dt` string COMMENT '时间分区(yyyyMMdd)')
stored as parquet
 LOCATION
   '/dw/hive/jms_ods.db/external/yl_cn_mysql_lmdm_sys_tail_dispatch_area_staff'
 TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );